<?php







/**



 * 蔓云电商 广告管理程序



 * ============================================================================



 * * 版权所有 2012-2014 北京蔓云网络科技有限公司，并保留所有权利。



 * 网站地址: http://www.xaphp.cn；



 * ----------------------------------------------------------------------------



 * 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和



 * 使用；不允许对程序代码以任何形式任何目的的再发布。



 * ============================================================================



 * $Author: pangbin $



 * $Id: ads.php 17217 2014-05-12 06:29:08Z pangbin $



*/







define('IN_HHS', true);







require(dirname(__FILE__) . '/includes/init.php');



include_once(ROOT_PATH . 'includes/cls_image.php');



$image = new cls_image($_CFG['bgcolor']);



$exc   = new exchange($hhs->table("ad"), $db, 'ad_id', 'ad_name');







/* act操作项的初始化 */



if (empty($_REQUEST['act']))



{



    $_REQUEST['act'] = 'list';



}



else



{



    $_REQUEST['act'] = trim($_REQUEST['act']);



}



 $smarty->assign('cities',    get_sitelists());



/*------------------------------------------------------ */



//-- 广告列表页面



/*------------------------------------------------------ */



if ($_REQUEST['act'] == 'list')



{

	/* 检查权限 */



    admin_priv('ads_list');



    $pid = !empty($_REQUEST['pid']) ? intval($_REQUEST['pid']) : 0;







    $smarty->assign('ur_here',     $_LANG['ad_list']);



    $smarty->assign('action_link', array('text' => $_LANG['ads_add'], 'href' => 'ads.php?act=add'));



    $smarty->assign('pid',         $pid);



     $smarty->assign('full_page',  1);







    $ads_list = get_adslist();







    $smarty->assign('ads_list',     $ads_list['ads']);



    $smarty->assign('filter',       $ads_list['filter']);



    $smarty->assign('record_count', $ads_list['record_count']);



    $smarty->assign('page_count',   $ads_list['page_count']);



    $sql = 'SELECT * FROM ' .$GLOBALS['hhs']->table('ad_position'). ' ORDER BY position_id DESC';

	

	$smarty->assign('ad_position_list',$db->getAll($sql));







    $sort_flag  = sort_flag($ads_list['filter']);



    $smarty->assign($sort_flag['tag'], $sort_flag['img']);







    assign_query_info();



    $smarty->display('ads_list.htm');



}







if ($_REQUEST['act'] == 'edit_sort_order')



{



    $id = intval($_POST['id']);



    $val = intval($_POST['val']);







    if ($db->query("update ".$hhs->table('ad')." set order_sort='$val' where ad_id='$id'"))



    {



        clear_cache_files(); // 清除缓存



        make_json_result($val);



    }



    else



    {



        make_json_error($db->error());



    }



}







/*------------------------------------------------------ */



//-- 排序、分页、查询



/*------------------------------------------------------ */



elseif ($_REQUEST['act'] == 'query')



{



    $ads_list = get_adslist();







    $smarty->assign('ads_list',     $ads_list['ads']);



    $smarty->assign('filter',       $ads_list['filter']);



    $smarty->assign('record_count', $ads_list['record_count']);



    $smarty->assign('page_count',   $ads_list['page_count']);







    $sort_flag  = sort_flag($ads_list['filter']);



    $smarty->assign($sort_flag['tag'], $sort_flag['img']);







    make_json_result($smarty->fetch('ads_list.htm'), '',



        array('filter' => $ads_list['filter'], 'page_count' => $ads_list['page_count']));



}







/*------------------------------------------------------ */



//-- 添加新广告页面



/*------------------------------------------------------ */



elseif ($_REQUEST['act'] == 'add')



{



    admin_priv('ad_add');







    $ad_link = empty($_GET['ad_link']) ? '' : trim($_GET['ad_link']);



    $ad_name = empty($_GET['ad_name']) ? '' : trim($_GET['ad_name']);







    $start_time = local_date('Y-m-d');



    $end_time   = local_date('Y-m-d', gmtime() + 3600 * 24 * 30);  // 默认结束时间为1个月以后







    $smarty->assign('ads',



        array('ad_link' => $ad_link, 'ad_name' => $ad_name, 'start_time' => $start_time,



            'end_time' => $end_time, 'enabled' => 1));







    $smarty->assign('ur_here',       $_LANG['ads_add']);



    $smarty->assign('action_link',   array('href' => 'ads.php?act=list', 'text' => $_LANG['ad_list']));



    $smarty->assign('position_list', get_position_list());



	$site_list = get_site_lists();
	
	$smarty->assign('site_list',       $site_list);



    $smarty->assign('form_act', 'insert');



    $smarty->assign('action',   'add');



    $smarty->assign('cfg_lang', $_CFG['lang']);







    assign_query_info();



    $smarty->display('ads_info.htm');



}







/*------------------------------------------------------ */



//-- 新广告的处理



/*------------------------------------------------------ */



elseif ($_REQUEST['act'] == 'insert')



{



    admin_priv('ad_add');







    /* 初始化变量 */



    $id      = !empty($_POST['id'])      ? intval($_POST['id'])    : 0;



    $type    = !empty($_POST['type'])    ? intval($_POST['type'])  : 0;



    $ad_name = !empty($_POST['ad_name']) ? trim($_POST['ad_name']) : '';







    // if ($_POST['media_type'] == '0')



    // {



        $ad_link = !empty($_POST['ad_link']) ? trim($_POST['ad_link']) : '';



    // }



    // else



    // {



    //     $ad_link = !empty($_POST['ad_link2']) ? trim($_POST['ad_link2']) : '';



    // }







    /* 获得广告的开始时期与结束日期 */



    $start_time = local_strtotime($_POST['start_time']);



    $end_time   = local_strtotime($_POST['end_time']);







    /* 查看广告名称是否有重复 */



    $sql = "SELECT COUNT(*) FROM " .$hhs->table('ad'). " WHERE ad_name = '$ad_name'";



    if ($db->getOne($sql) > 0)



    {



        $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');



        sys_msg($_LANG['ad_name_exist'], 0, $link);



    }







    /* 添加图片类型的广告 */



    if ($_POST['media_type'] == '0')



    {



        if ((isset($_FILES['ad_img']['error']) && $_FILES['ad_img']['error'] == 0) || (!isset($_FILES['ad_img']['error']) && isset($_FILES['ad_img']['tmp_name'] ) &&$_FILES['ad_img']['tmp_name'] != 'none'))



        {



            $ad_code = basename($image->upload_image($_FILES['ad_img'], 'afficheimg'));



        }



        if (!empty($_POST['img_url']))



        {



            $ad_code = $_POST['img_url'];



        }



        if (((isset($_FILES['ad_img']['error']) && $_FILES['ad_img']['error'] > 0) || (!isset($_FILES['ad_img']['error']) && isset($_FILES['ad_img']['tmp_name']) && $_FILES['ad_img']['tmp_name'] == 'none')) && empty($_POST['img_url']))



        {



            $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');



            sys_msg($_LANG['js_languages']['ad_photo_empty'], 0, $link);



        }



    }







    /* 如果添加的广告是Flash广告 */



    elseif ($_POST['media_type'] == '1')



    {



        if ((isset($_FILES['upfile_flash']['error']) && $_FILES['upfile_flash']['error'] == 0) || (!isset($_FILES['upfile_flash']['error']) && isset($_FILES['ad_img']['tmp_name']) && $_FILES['upfile_flash']['tmp_name'] != 'none'))



        {



            /* 检查文件类型 */



            if ($_FILES['upfile_flash']['type'] != "application/x-shockwave-flash")



            {



                $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');



                sys_msg($_LANG['upfile_flash_type'], 0, $link);



            }







            /* 生成文件名 */



            $urlstr = date('Ymd');



            for ($i = 0; $i < 6; $i++)



            {



                $urlstr .= chr(mt_rand(97, 122));



            }







            $source_file = $_FILES['upfile_flash']['tmp_name'];



            $target      = ROOT_PATH . DATA_DIR . '/afficheimg/';



            $file_name   = $urlstr .'.swf';







            if (!move_upload_file($source_file, $target.$file_name))



            {



                $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');



                sys_msg($_LANG['upfile_error'], 0, $link);



            }



            else



            {



                $ad_code = $file_name;



            }



        }



        elseif (!empty($_POST['flash_url']))



        {



            if (substr(strtolower($_POST['flash_url']), strlen($_POST['flash_url']) - 4) != '.swf')



            {



                $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');



                sys_msg($_LANG['upfile_flash_type'], 0, $link);



            }



            $ad_code = $_POST['flash_url'];



        }







        if (((isset($_FILES['upfile_flash']['error']) && $_FILES['upfile_flash']['error'] > 0) || (!isset($_FILES['upfile_flash']['error']) && isset($_FILES['upfile_flash']['tmp_name']) && $_FILES['upfile_flash']['tmp_name'] == 'none')) && empty($_POST['flash_url']))



        {



            $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');



            sys_msg($_LANG['js_languages']['ad_flash_empty'], 0, $link);



        }



    }



    /* 如果广告类型为代码广告 */



    elseif ($_POST['media_type'] == '2')



    {



        if (!empty($_POST['ad_code']))



        {



            $ad_code = $_POST['ad_code'];



        }



        else



        {



            $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');



            sys_msg($_LANG['js_languages']['ad_code_empty'], 0, $link);



        }



    }







    /* 广告类型为文本广告 */



    elseif ($_POST['media_type'] == '3')



    {



        if (!empty($_POST['ad_text']))



        {



            $ad_code = $_POST['ad_text'];



        }



        else



        {



            $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');



            sys_msg($_LANG['js_languages']['ad_text_empty'], 0, $link);



        }



    }







    /* 插入数据 */



    $sql = "INSERT INTO ".$hhs->table('ad'). " (ad_width,city_id,position_id,media_type,ad_name,ad_link,ad_code,start_time,end_time,link_man,link_email,link_phone,click_count,enabled)



    VALUES (



			'$_POST[ad_width]',



			'$_POST[city_id]',



			'$_POST[position_id]',



            '$_POST[media_type]',



            '$ad_name',



            '$ad_link',



            '$ad_code',



            '$start_time',



            '$end_time',



            '$_POST[link_man]',



            '$_POST[link_email]',



            '$_POST[link_phone]',



            '0',



            '1')";







    $db->query($sql);



    /* 记录管理员操作 */



    admin_log($_POST['ad_name'], 'add', 'ads');







    clear_cache_files(); // 清除缓存文件







    /* 提示信息 */















    $link[0]['text'] = $_LANG['back_ads_list'];



    $link[0]['href'] = 'ads.php?act=list';







    $link[1]['text'] = $_LANG['continue_add_ad'];



    $link[1]['href'] = 'ads.php?act=add';



    sys_msg($_LANG['add'] . "&nbsp;" .$_POST['ad_name'] . "&nbsp;" . $_LANG['attradd_succed'],0, $link);







}







/*------------------------------------------------------ */



//-- 广告编辑页面



/*------------------------------------------------------ */



elseif ($_REQUEST['act'] == 'edit')



{



    admin_priv('ad_add');







    /* 获取广告数据 */



    $sql = "SELECT * FROM " .$hhs->table('ad'). " WHERE ad_id='".intval($_REQUEST['id'])."'";



    $ads_arr = $db->getRow($sql);


	$site_list = get_site_lists();
	
	$smarty->assign('site_list',       $site_list);




    $ads_arr['ad_name'] = htmlspecialchars($ads_arr['ad_name']);



    /* 格式化广告的有效日期 */



    $ads_arr['start_time']  = local_date('Y-m-d', $ads_arr['start_time']);



    $ads_arr['end_time']    = local_date('Y-m-d', $ads_arr['end_time']);







    if ($ads_arr['media_type'] == '0')



    {



        if (strpos($ads_arr['ad_code'], 'http://') === false && strpos($ads_arr['ad_code'], 'https://') === false)



        {



            $src = '../' . DATA_DIR . '/afficheimg/'. $ads_arr['ad_code'];



            $smarty->assign('img_src', $src);



        }



        else



        {



            $src = $ads_arr['ad_code'];



            $smarty->assign('url_src', $src);



        }



    }



    if ($ads_arr['media_type'] == '1')



    {



        if (strpos($ads_arr['ad_code'], 'http://') === false && strpos($ads_arr['ad_code'], 'https://') === false)



        {



            $src = '../' . DATA_DIR . '/afficheimg/'. $ads_arr['ad_code'];



            $smarty->assign('flash_url', $src);



        }



        else



        {



            $src = $ads_arr['ad_code'];



            $smarty->assign('flash_url', $src);



        }



        $smarty->assign('src', $src);



    }



    if ($ads_arr['media_type'] == 0)



    {



        $smarty->assign('media_type', $_LANG['ad_img']);



    }



    elseif ($ads_arr['media_type'] == 1)



    {



        $smarty->assign('media_type', $_LANG['ad_flash']);



    }



    elseif ($ads_arr['media_type'] == 2)



    {



        $smarty->assign('media_type', $_LANG['ad_html']);



    }



    elseif ($ads_arr['media_type'] == 3)



    {



        $smarty->assign('media_type', $_LANG['ad_text']);



    }







    $smarty->assign('ur_here',       $_LANG['ads_edit']);



    $smarty->assign('action_link',   array('href' => 'ads.php?act=list', 'text' => $_LANG['ad_list']));



    $smarty->assign('form_act',      'update');



    $smarty->assign('action',        'edit');



    $smarty->assign('position_list', get_position_list());



    $smarty->assign('ads',           $ads_arr);







    assign_query_info();



    $smarty->display('ads_info.htm');



}







/*------------------------------------------------------ */



//-- 广告编辑的处理



/*------------------------------------------------------ */



elseif ($_REQUEST['act'] == 'update')



{



    admin_priv('ad_add');







    /* 初始化变量 */



    $id   = !empty($_POST['id'])   ? intval($_POST['id'])   : 0;



    $type = !empty($_POST['media_type']) ? intval($_POST['media_type']) : 0;







    // if ($_POST['media_type'] == '0')



    // {



        $ad_link = !empty($_POST['ad_link']) ? trim($_POST['ad_link']) : '';



    // }



    // else



    // {



    //     $ad_link = !empty($_POST['ad_link2']) ? trim($_POST['ad_link2']) : '';



    // }







    /* 获得广告的开始时期与结束日期 */



    $start_time = local_strtotime($_POST['start_time']);



    $end_time   = local_strtotime($_POST['end_time']);







    /* 编辑图片类型的广告 */



    if ($type == 0)



    {



        if ((isset($_FILES['ad_img']['error']) && $_FILES['ad_img']['error'] == 0) || (!isset($_FILES['ad_img']['error']) && isset($_FILES['ad_img']['tmp_name']) && $_FILES['ad_img']['tmp_name'] != 'none'))



        {



            $img_up_info = basename($image->upload_image($_FILES['ad_img'], 'afficheimg'));



            $ad_code = "ad_code = '".$img_up_info."'".',';



        }



        else



        {



            $ad_code = '';



        }



        if (!empty($_POST['img_url']))



        {



            $ad_code = "ad_code = '$_POST[img_url]', ";



        }



    }







    /* 如果是编辑Flash广告 */



    elseif ($type == 1)



    {



        if ((isset($_FILES['upfile_flash']['error']) && $_FILES['upfile_flash']['error'] == 0) || (!isset($_FILES['upfile_flash']['error']) && isset($_FILES['upfile_flash']['tmp_name']) && $_FILES['upfile_flash']['tmp_name'] != 'none'))



        {



            /* 检查文件类型 */



            if ($_FILES['upfile_flash']['type'] != "application/x-shockwave-flash")



            {



                $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');



                sys_msg($_LANG['upfile_flash_type'], 0, $link);



            }



            /* 生成文件名 */



            $urlstr = date('Ymd');



            for ($i = 0; $i < 6; $i++)



            {



                $urlstr .= chr(mt_rand(97, 122));



            }







            $source_file = $_FILES['upfile_flash']['tmp_name'];



            $target      = ROOT_PATH . DATA_DIR . '/afficheimg/';



            $file_name   = $urlstr .'.swf';







            if (!move_upload_file($source_file, $target.$file_name))



            {



                $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');



                sys_msg($_LANG['upfile_error'], 0, $link);



            }



            else



            {



                $ad_code = "ad_code = '$file_name', ";



            }



        }



        elseif (!empty($_POST['flash_url']))



        {



            if (substr(strtolower($_POST['flash_url']), strlen($_POST['flash_url']) - 4) != '.swf')



            {



                $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');



                sys_msg($_LANG['upfile_flash_type'], 0, $link);



            }



            $ad_code = "ad_code = '".$_POST['flash_url']."', ";



        }



        else



        {



            $ad_code = '';



        }







    }







    /* 编辑代码类型的广告 */



    elseif ($type == 2)



    {



        $ad_code = "ad_code = '$_POST[ad_code]', ";



    }







    /* 编辑文本类型的广告 */



    if ($type == 3)



    {



        $ad_code = "ad_code = '$_POST[ad_text]', ";



    }







    $ad_code = str_replace('../' . DATA_DIR . '/afficheimg/', '', $ad_code);



    /* 更新信息 */



    $sql = "UPDATE " .$hhs->table('ad'). " SET ".



            "position_id = '$_POST[position_id]', ".



            "ad_name     = '$_POST[ad_name]', ".



			"city_id     = '$_POST[city_id]', ".



			"ad_width     = '$_POST[ad_width]', ".



            "ad_link     = '$ad_link', ".



            $ad_code.



            "start_time  = '$start_time', ".



            "end_time    = '$end_time', ".



            "link_man    = '$_POST[link_man]', ".



            "link_email  = '$_POST[link_email]', ".



            "link_phone  = '$_POST[link_phone]', ".



            "enabled     = '$_POST[enabled]' ".



            "WHERE ad_id = '$id'";



    $db->query($sql);







   /* 记录管理员操作 */



   admin_log($_POST['ad_name'], 'edit', 'ads');







   clear_cache_files(); // 清除模版缓存







   /* 提示信息 */



   $href[] = array('text' => $_LANG['back_ads_list'], 'href' => 'ads.php?act=list');



   sys_msg($_LANG['edit'] .' '.$_POST['ad_name'].' '. $_LANG['attradd_succed'], 0, $href);







}







/*------------------------------------------------------ */



//--生成广告的JS代码



/*------------------------------------------------------ */



elseif ($_REQUEST['act'] == 'add_js')



{



    admin_priv('ad_add');







    /* 编码 */



    $lang_list = array(



        'UTF8'   => $_LANG['charset']['utf8'],



        'GB2312' => $_LANG['charset']['zh_cn'],



        'BIG5'   => $_LANG['charset']['zh_tw'],



    );







    $js_code  = "<script type=".'"'."text/javascript".'"';



    $js_code .= ' src='.'"'.$hhs->url().'affiche.php?act=js&type='.$_REQUEST['type'].'&ad_id='.intval($_REQUEST['id']).'"'.'></script>';







    $site_url = $hhs->url().'affiche.php?act=js&type='.$_REQUEST['type'].'&ad_id='.intval($_REQUEST['id']);







    $smarty->assign('ur_here',     $_LANG['add_js_code']);



    $smarty->assign('action_link', array('href' => 'ads.php?act=list', 'text' => $_LANG['ad_list']));



    $smarty->assign('url',         $site_url);



    $smarty->assign('js_code',     $js_code);



    $smarty->assign('lang_list',   $lang_list);







    assign_query_info();



    $smarty->display('ads_js.htm');



}







/*------------------------------------------------------ */



//-- 编辑广告名称



/*------------------------------------------------------ */



elseif ($_REQUEST['act'] == 'edit_ad_name')



{



    check_authz_json('ad_add');







    $id      = intval($_POST['id']);



    $ad_name = json_str_iconv(trim($_POST['val']));







    /* 检查广告名称是否重复 */



    if ($exc->num('ad_name', $ad_name, $id) != 0)



    {



        make_json_error(sprintf($_LANG['ad_name_exist'], $ad_name));



    }



    else



    {



        if ($exc->edit("ad_name = '$ad_name'", $id))



        {



            admin_log($ad_name,'edit','ads');



            make_json_result(stripslashes($ad_name));



        }



        else



        {



            make_json_error($db->error());



        }



    }



}







/*------------------------------------------------------ */



//-- 删除广告位置



/*------------------------------------------------------ */



elseif ($_REQUEST['act'] == 'remove')



{



    check_authz_json('ad_remove');







    $id = intval($_GET['id']);



    $img = $exc->get_name($id, 'ad_code');







    $exc->drop($id);







    if ((strpos($img, 'http://') === false) && (strpos($img, 'https://') === false))



    {



        $img_name = basename($img);



        @unlink(ROOT_PATH. DATA_DIR . '/afficheimg/'.$img_name);



    }







    admin_log('', 'remove', 'ads');







    $url = 'ads.php?act=query&' . str_replace('act=remove', '', $_SERVER['QUERY_STRING']);







    hhs_header("Location: $url\n");



    exit;



}







/* 获取广告数据列表 */



function get_adslist()



{



    /* 过滤查询 */



    $pid = !empty($_REQUEST['pid']) ? intval($_REQUEST['pid']) : 0;







    $filter = array();



    $filter['sort_by']    = empty($_REQUEST['sort_by']) ? 'ad.ad_name' : trim($_REQUEST['sort_by']);



    $filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);



	



	$filter['city_id'] = empty($_REQUEST['sort_order']) ? '' : trim($_REQUEST['city_id']);



	$filter['position_id'] = empty($_REQUEST['position_id']) ? '' : trim($_REQUEST['position_id']);







    $where = 'WHERE 1 ';



    if ($pid > 0)



    {



        $where .= " AND ad.position_id = '$pid' ";



    }



	if($filter['city_id'] )



	{



        $where .= " AND ad.city_id = '$filter[city_id]' ";



	}



	



	if($filter['position_id'] )



	{



        $where .= " AND ad.position_id = '$filter[position_id]' ";



	}



	







    /* 获得总记录数据 */



    $sql = 'SELECT COUNT(*) FROM ' .$GLOBALS['hhs']->table('ad'). ' AS ad ' . $where;



    $filter['record_count'] = $GLOBALS['db']->getOne($sql);







    $filter = page_and_size($filter);







    /* 获得广告数据 */



    $arr = array();



    $sql = 'SELECT ad.*, COUNT(o.order_id) AS ad_stats, p.position_name '.



            'FROM ' .$GLOBALS['hhs']->table('ad'). 'AS ad ' .



            'LEFT JOIN ' . $GLOBALS['hhs']->table('ad_position'). ' AS p ON p.position_id = ad.position_id '.



            'LEFT JOIN ' . $GLOBALS['hhs']->table('order_info'). " AS o ON o.from_ad = ad.ad_id $where " .



            'GROUP BY ad.ad_id '.



            'ORDER by '.$filter['sort_by'].' '.$filter['sort_order'];







    $res = $GLOBALS['db']->selectLimit($sql, $filter['page_size'], $filter['start']);







    while ($rows = $GLOBALS['db']->fetchRow($res))



    {



         /* 广告类型的名称 */



         $rows['type']  = ($rows['media_type'] == 0) ? $GLOBALS['_LANG']['ad_img']   : '';



         $rows['type'] .= ($rows['media_type'] == 1) ? $GLOBALS['_LANG']['ad_flash'] : '';



         $rows['type'] .= ($rows['media_type'] == 2) ? $GLOBALS['_LANG']['ad_html']  : '';



         $rows['type'] .= ($rows['media_type'] == 3) ? $GLOBALS['_LANG']['ad_text']  : '';







         /* 格式化日期 */



         $rows['start_date']    = local_date($GLOBALS['_CFG']['date_format'], $rows['start_time']);



         $rows['end_date']      = local_date($GLOBALS['_CFG']['date_format'], $rows['end_time']);







         $arr[] = $rows;



    }







    return array('ads' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);



}


//获取添加的站点列表
function get_site_lists()
{
	$cities_id_list = $GLOBALS['db']->getAll('SELECT city_id FROM ' .$GLOBALS['hhs']->table('site'));
	
	foreach ($cities_id_list as $key => $value)
	{
	
		$cities_id_list[$key]['region_name'] =get_region_name($value['city_id']);
		
	}
	
	return $cities_id_list;
}




?>



